

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
<script type="text/javascript" src="helpman_topicinit.js"></script>

<title>Create Foreign Key [Enterprise Architect User Guide]</title>

<meta name="keywords" content="Enterprise Architect, Sparx Systems, UML, Foreign Key,Foreign Key Create,Foreign Key Composite,Foreign Key Constraint,Foreign Key Representation In Diagram,Create,Create Foreign Key,Composite,Composite Foreign Key">
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta http-equiv="Content-Style-Type" content="text/css" />

<link type="text/css" href="default.css" rel="stylesheet" />
<style type="text/css">
  A, A:Visited
  {
    color: #00F;
  }

  A:Active, A:Hover
  {
    color: #F00;
  }

  OL
  {
    margin: 5px 0 5px 48px;
  }

  UL
  {
    margin-bottom: 3px;
    margin-top: 0;
  }

  #nsr
  {
    background-color: #D4DFFF;
  }

  #nsr A
  {
    text-decoration: none;
  }

  #mainbody
  {
    padding: 8px;
  }

  .p_BodyText
  {
    padding: 5px 0;
  }
</style>



<style type="text/css" media="screen">
  BODY
  {
    background-color: #FFFFFF;
  }

  #nsr
  {
    padding: 6px 6px 0 6px;
    border-bottom: none;
    vertical-align: top;
    z-index: 2;
    visibility: visible;
    left: 0;
    top: 0;
    position: absolute;
  }

  #mainbody
  {
    left: 0;
    top: 0;
    margin: 0;
    position: absolute;
    padding: 10px;
    overflow: auto;
    height: 100%;
    z-index: 1;
    background-repeat: no-repeat;
    background-position: bottom right;
    background-attachment: fixed;
  }
</style>

<style type="text/css" media="print">
  #nsr
  {
    visibility: none;
  }

  #mainbody
  {
    overflow: visible;
  }
</style>
<script type="text/javascript" language="JavaScript" src="nonscroll.js"></script>

</head>
<body scroll="no">

<div id="page">



        <div id="content">
          <div id="content-inner">
          



  
          <div id="nsr">
            <table border="0" cellspacing="0" cellpadding="4" width="100%">
              <tr valign="top">
                <td align="left">
  


                  <p class="p_Heading1"><span class="f_Heading1">Create Foreign Key</span></p>



  
                </td>
                <td align="right">
                  <a href="introduction.htm" onmouseover="document.images.main.src='button_main_h.gif'" onmouseout="document.images.main.src='button_main.gif'">
                    <img name="main" src="button_main.gif" border=0 alt="Return to Introduction">
                  </a>&nbsp;
    
                  <a href="foreignkeys.htm" onmouseover="document.images.prev.src='button_prev_h.gif'" onmouseout="document.images.prev.src='button_prev.gif'">
                    <img name=prev src="button_prev.gif" border=0 alt="Previous page" />
                  </a>&nbsp;
    
    
    
                  <a href="define_a_foreign_key_name_temp.htm" onmouseover="document.images.next.src='button_next_h.gif'" onmouseout="document.images.next.src='button_next.gif'">
                    <img name=next src="button_next.gif" border=0 alt="Next page" />
                  </a>
    
    
                </td>
              </tr>
            </table>
          </div>
          <div id="mainbody">
  


                <p class="p_BodyText"><span class="f_BodyText">To create a Foreign Key, follow the steps below:</span></p>
<ol style="text-indent: 0px; margin-left: 48px; list-style-position: outside;">
<li value=1><span class="f_NumberedList">Locate the required Tables in a diagram.</span></li>
<li value=2><span class="f_NumberedList">Select an </span><span class="f_NumberedList" style="font-style: italic;">Associate</span><span class="f_NumberedList"> connector in the </span><span class="f_UIControl">Class Relationships </span><span class="f_NumberedList">page of the Enterprise Architect UML</span><span class="f_UIControl"> Toolbox</span><span class="f_NumberedList">.</span></li>
<li value=3><span class="f_NumberedList">Click on the Table to contain the Foreign Key (source) and draw the connector to the other Table (target).</span></li>
<li value=4><span class="f_NumberedList">Right-click on the connector to display the context menu, and select the </span><span class="f_MenuKeyField">Foreign Keys</span><span class="f_NumberedList"> option. The </span><span class="f_UIControl">Foreign Key Constraint</span><span class="f_NumberedList"> dialog displays.</span><br>
<span class="f_NumberedList">&nbsp;</span><br>
<img src="foreignkeyconstraint.png" width="515" height="588" border="0" alt="ForeignKeyConstraint"></li>
</ol>
<p class="p_NumberedList"><span class="f_NumberedList">&nbsp;</span></p>
<ol style="text-indent: 0px; margin-left: 48px; list-style-position: outside;">
<li value=5><span class="f_NumberedList">If necessary, edit the default name for the Foreign Key.</span></li>
<li value=6><span class="f_NumberedList">Highlight the columns involved in the Foreign Key relationship.</span></li>
<li value=7><span class="f_NumberedList">Click on the </span><span class="f_MenuKeyField">Save</span><span class="f_NumberedList"> button to automatically generate the Foreign Key operations.</span></li>
</ol>
<p class="p_BodyText"><span class="f_BodyText">You have created the Foreign Key. The example below shows how this looks in a diagram:</span></p>
<p class="p_TextIndentedL2"><img src="primarykeydiagram.png" width="791" height="574" border="0" alt="PrimaryKeyDiagram"></p>
<p class="p_SubHeadingL1"><span class="f_SubHeadingL1">Composite Foreign Key</span></p>
<p class="p_BodyText"><span class="f_BodyText">To create a composite Foreign Key, select the appropriate columns and click on the </span><span class="f_MenuKeyField">Save</span><span class="f_BodyText"> button. The Foreign Key columns are sorted according to datatype to match the datatypes of the targeted composite Primary Key. If required, you can change the order of the key columns by clicking on the </span><img src="uphand.png" width="27" height="24" border="0" alt="uphand"><span class="f_BodyText"> and </span><img src="downhand.png" width="27" height="24" border="0" alt="downhand"><span class="f_BodyText"> buttons.</span></p>
<div style="text-align: left; text-indent: 0px; padding: 0px 0px 0px 0px; margin: 5px 0px 5px 13px;"><table cellspacing="0" cellpadding="2" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:bottom;">
<td valign="bottom" width="952" bgcolor="#efeff7" style="width:952px; background-color:#efeff7;"><p class="p_TiporNote" style="border-top: none; border-right: none; border-left: none;"><span class="f_TiporNote">Tip:</span></p>
</td>
</tr>
<tr style="text-align:left;">
<td width="952" bgcolor="#f7f7ff" style="width:952px; background-color:#f7f7ff;"><p class="p_TiporNoteText"><span class="f_TiporNoteText">If you are defining a MySQL database and want to use Foreign Keys, you must <a href="setmysqltabletype.htm">set the table type</a> to enable this.</span></p>
</td>
</tr>
</table>
</div>
<p class="p_TextIndentedL2"><img src="compositeforeignkey.png" width="515" height="554" border="0" alt="CompositeForeignKey"></p>
<p class="p_BodyText"><span class="f_BodyText">This creates the composite Foreign Key. The example below shows how this looks in a diagram:</span></p>
<p class="p_TextIndentedL2"><img src="foreignkey.png" width="451" height="503" border="0" alt="ForeignKey"></p>




            </div>
          </div>
        </div>



</div>


</body>
</html>
